Comparison Unit price vs Fuel type
Comparison Price comsuption per State
Name of stations vs State
A glimpse of the data
Unnamed: 0.1 Unnamed: 0 SiteId Site_Name Site_Brand Sites_Address_Line_1 Site_Suburb Site_State Site_Post_Code Site_Latitude Site_Longitude Fuel_Type Price TransactionDateutc X_id unit_price
0 0 1 61290151 Liberty Surat Liberty 61 Burrowes Street Surat QLD 4417 -27.151687 149.067742 Diesel 1999 2023-10-12 21:56:00 NaN 1.999
1 1 2 61290151 Liberty Surat Liberty 61 Burrowes Street Surat QLD 4417 -27.151687 149.067742 PULP 98 RON 2159 2023-12-30 06:54:00 NaN 2.159
2 2 3 61290151 Liberty Surat Liberty 61 Burrowes Street Surat QLD 4417 -27.151687 149.067742 Unleaded 1959 2023-12-30 06:54:00 NaN 1.959
3 3 4 61291313 Lowes Mungindi Opt BP 126 Barwon Street Mungindi QLD 4497 -28.973467 148.983829 Diesel 1990 2023-06-12 22:00:00 NaN 1.990
4 4 5 61291313 Lowes Mungindi Opt BP 126 Barwon Street Mungindi QLD 4497 -28.973467 148.983829 Unleaded 1920 2023-06-12 22:00:00 NaN 1.920
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
615624 615972 615973 61478211 Metro Petroleum Walkerston Metro Fuel 2 Dutton St Walkerston QLD 4751 -21.160166 149.063728 Unleaded 1959 2023-09-20 05:14:00 NaN 1.959
615625 615973 615974 61478211 Metro Petroleum Walkerston Metro Fuel 2 Dutton St Walkerston QLD 4751 -21.160166 149.063728 Unleaded 1989 2023-09-25 08:08:00 NaN 1.989
615626 615974 615975 61478212 Pitt Stop Classic Café Independent 34 Palm Ave Seaforth QLD 4741 -20.899741 148.964986 Unleaded 2049 2023-04-09 04:15:00 NaN 2.049
615627 615975 615976 61478212 Pitt Stop Classic Café Independent 34 Palm Ave Seaforth QLD 4741 -20.899741 148.964986 Unleaded 2039 2023-04-09 04:24:00 NaN 2.039
615628 615976 615977 61478212 Pitt Stop Classic Café Independent 34 Palm Ave Seaforth QLD 4741 -20.899741 148.964986 Unleaded 2099 2023-09-25 06:26:00 NaN 2.099

615629 rows × 16 columns

Statistics unit price 
count    615629.000000
mean          2.006312
std           0.196784
min           0.799000
25%           1.869000
50%           1.999000
75%           2.139000
max           3.610000
Name: unit_price, dtype: float64

Average price $:

2.006312449543475